﻿CREATE PROCEDURE [dbo].[proc_ManagementArea_GetList]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	--Select Id, CompanyName,Startletter,CompanyNumber,CompanyPhone,CompanyFax,CompanyAddress,Zip,ContactPerson,ContactPhone,ContactEmail,WebAddress,Products From ManagementArea Order by CompanyNumber
	
	Select Id, CompanyName,Startletter,CompanyNumber,CompanyPhone,CompanyFax,CompanyAddress,Zip,
	ContactPerson,ContactPhone,ContactEmail,WebAddress,Products From ManagementArea
	WHERE flag=0
	 Order by CompanyNumber
	
	RETURN
